package com.example.demo.mapper.order;

import java.util.List;

import com.example.demo.domain.order.SaleOrder;

public interface SaleOrderMapper {
    int deleteByPrimaryKey(Integer orderId);

    int insert(SaleOrder saleOrder);

    int insertSelective(SaleOrder saleOrder);

    SaleOrder selectByPrimaryKey(Integer orderId);

    int updateByPrimaryKeySelective(SaleOrder saleOrder);

    int updateByPrimaryKey(SaleOrder saleOrder);

    List<SaleOrder> selectSaleOrderList(SaleOrder saleOrder);

    SaleOrder selectBySaleOrderNo(String saleorderno);

    //按理发师的销售额查询
    List<SaleOrder> sumTotalByBarber(SaleOrder saleOrder);

    //查询某年下每月的销售情况
    List<SaleOrder> sumTotalByMonth(String year);

    //对比不同年份的总销售额
    List<SaleOrder> compareTotalByYears();

    //对比某一年份下的不同季度
    List<SaleOrder> compareByQuarter(String year);

    //计算近七日的营业额
    List<SaleOrder> inSevenDays();

    //按服务项目查销售额
    List<SaleOrder> sumByService(SaleOrder saleOrder);

    //按服务类型查销售额
    List<SaleOrder> sumByTos(SaleOrder saleOrder);

}